package cn.com.dcsgo.domain.bo;

import lombok.Data;

/**
 * 客户历史交易总额信息
 *
 * @author Dcsgo
 * @since 15/5/2025 上午 11:53
 */
@Data
public class CustomerTotalHistoricalTransactionAmountBO {
    /**
     * 客户id
     */
    private Long custId;
    /**
     * 历史交易总额
     */
    private Double totalHistoricalTransactionAmount;
}

/*

SELECT
	`order`.cust_id cust_id,
	sum( item.price * `order`.quantity ) total_historical_transaction_amount
FROM
	`order`
	JOIN item ON `order`.item_id = item.id
GROUP BY
	`order`.cust_id;
 */